forum

Home / DeveloperSection / Forums / How can I get a column details and their data type by using stored procedure in SQL server ?

How can I get a column details and their data type by using stored procedure in SQL server ?

Anonymous User 1309 28-Feb-2019

Please give me a suitable example for it.

sql server sql server 2008 sql server 2012

Updated on 03-Apr-2019

I am a content writter !

Can you answer this question?

Answer

28-Feb-2019

If you want to get Stored Procedure Result Column details and datatype Types use the following Script:

EXEC sp_describe_first_result_set N'YourStoredProcedureName'

If you want to get table Column details and datatype Types or Name use the following Script:

exec sp_columns yourtablename